Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
CalendarLevelID (FK) | A unique system assigned identifier for the CalendarLevel. | ID_CLD_LV | Identity | integer | CalendarPeriod(CA_CLD_PRD) |
CalendarID (FK) | A unique system assigned identifier for the Calendar. | ID_CLD | Identity | integer | CalendarPeriod(CA_CLD_PRD) |
ReportingPeriodID (PK) | The unique system assigned identifier for a particular ReportingPeriod. | ID_PRD_RP | Identity | integer | |
CalendarID (FK) | A unique system assigned identifier for the Calendar. | ID_CLD | Identity | integer | CalendarPeriod(CA_CLD_PRD) |
CalendarLevelID (FK) | A unique system assigned identifier for the CalendarLevel. | ID_CLD_LV | Identity | integer | CalendarPeriod(CA_CLD_PRD) |
StartCalendarPeriodID (FK) | A unique system assigned identifier for this CalendarPeriod | ID_CLD_PRD_SRT | Identity | integer | CalendarPeriod(CA_CLD_PRD) |
EndCalendarPeriodID (FK) | A unique system assigned identifier for this CalendarPeriod | ID_CLD_PRD_END | Identity | integer | CalendarPeriod(CA_CLD_PRD) |
Name | The business name for the reporting period. | NM_PRD_RP | Name | varchar(40) | |